*-----------------------------------------------------------------
version 10
cap clear
cap log close
set more off
cd "E:\REStat_MS14767_Vol96(2)\Data preparation Compustat"
log using "2_compustatamerica.log", replace
*-----------------------------------------------------------------

****************************************
* This short file only drops non-american firms
* from the compustat data set and creates a small
* set with the country information.
****************************************

set mem 600m

use "clean_compustat_master.dta", clear

keep ticker countryinc year
so ticker year

save "ticker_country.dta", replace


use "clean_compustat_master.dta", clear

drop if countryinc!=0

save compustat_master_america.dta, replace

log close
